using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class DMS027_SBL_VIEWManagerBase
    {
        public DMS027_SBL_VIEWManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity Insert(DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity Update(DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.Update(obj);             
        }
 
 
        public DMS027_SBL_VIEWEntity Delete(DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_NO (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_NO (string ORDER_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_DAT 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_DAT (string ORDER_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_DAT = ORDER_DAT;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_TIM (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_TIM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_TIM 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_TIM (string ORDER_TIM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_TIM = ORDER_TIM;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_TIM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteBySTOCK_OUT_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STOCK_OUT_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STOCK_OUT_DAT 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteBySTOCK_OUT_DAT (string STOCK_OUT_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STOCK_OUT_DAT = STOCK_OUT_DAT;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STOCK_OUT_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_OPTR (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_OPTR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_OPTR 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByORDER_OPTR (string ORDER_OPTR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_OPTR = ORDER_OPTR;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ORDER_OPTR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteBySTATUS (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteBySTATUS (string STATUS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTYPE_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TYPE_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TYPE_CODE 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTYPE_CODE (string TYPE_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TYPE_CODE = TYPE_CODE;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TYPE_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByBP_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BP_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BP_CODE 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByBP_CODE (string BP_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.BP_CODE = BP_CODE;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"BP_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTOTAL (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TOTAL 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTOTAL (double TOTAL )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTAL = TOTAL;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TOTAL");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByFIRST_ALL_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"FIRST_ALL_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FIRST_ALL_DAT 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByFIRST_ALL_DAT (string FIRST_ALL_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.FIRST_ALL_DAT = FIRST_ALL_DAT;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"FIRST_ALL_DAT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRPO_NO (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RPO_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RPO_NO 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRPO_NO (string RPO_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RPO_NO = RPO_NO;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RPO_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRMRK1 (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RMRK1");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RMRK1 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRMRK1 (string RMRK1 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK1 = RMRK1;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RMRK1");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRMRK2 (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RMRK2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RMRK2 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByRMRK2 (string RMRK2 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK2 = RMRK2;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"RMRK2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByACTFLG (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByACTFLG (string ACTFLG )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDUSR (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDUSR (string CTDUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDWKS (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDWKS (string CTDWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDPGM (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDPGM (string CTDPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDDTM (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCTDDTM (DateTime CTDDTM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFUSR (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFUSR (string MDFUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFWKS (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFWKS (string MDFWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFPGM (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByMDFPGM (string MDFPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByLSTMDF (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByLSTMDF (DateTime LSTMDF )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByWH_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByWH_CODE (string WH_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCOUNT (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"COUNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien COUNT 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByCOUNT (int COUNT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.COUNT = COUNT;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"COUNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTOTALQTY (DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TOTALQTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TOTALQTY 
        /// </summary>
        /// <returns>DMS027_SBL_VIEWEntity</returns>
        public DMS027_SBL_VIEWEntity DeleteByTOTALQTY (double TOTALQTY )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTALQTY = TOTALQTY;  
            return (DMS027_SBL_VIEWEntity)Adapter.DeleteByField(obj,"TOTALQTY");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public DMS027_SBL_VIEWEntity Select(DMS027_SBL_VIEWEntity obj)
        { 
            return (DMS027_SBL_VIEWEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS027_SBL_VIEWEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS027_SBL_VIEWEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new DMS027_SBL_VIEWEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new DMS027_SBL_VIEWEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS027_SBL_VIEWEntity> SelectAllLST()
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS027_SBL_VIEWEntity()),new DMS027_SBL_VIEWEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS027_SBL_VIEWEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS027_SBL_VIEWEntity(),option),new DMS027_SBL_VIEWEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_NOLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_NOLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_NO",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_NOLST (string ORDER_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_NOLST (string ORDER_NO, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_DAT (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_DATLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_DATLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_DAT (string ORDER_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_DAT = ORDER_DAT;  
            return Adapter.SelectByField(obj,"ORDER_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_DAT (string ORDER_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_DAT = ORDER_DAT;  
            return Adapter.SelectByField(obj,"ORDER_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_DATLST (string ORDER_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_DAT = ORDER_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_DATLST (string ORDER_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_DAT = ORDER_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_TIM (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_TIM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_TIM (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_TIM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_TIMLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_TIM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_TIMLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_TIM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_TIM (string ORDER_TIM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_TIM = ORDER_TIM;  
            return Adapter.SelectByField(obj,"ORDER_TIM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_TIM (string ORDER_TIM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_TIM = ORDER_TIM;  
            return Adapter.SelectByField(obj,"ORDER_TIM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_TIMLST (string ORDER_TIM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_TIM = ORDER_TIM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_TIM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_TIM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_TIMLST (string ORDER_TIM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_TIM = ORDER_TIM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_TIM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTOCK_OUT_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"STOCK_OUT_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTOCK_OUT_DAT (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"STOCK_OUT_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTOCK_OUT_DATLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STOCK_OUT_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTOCK_OUT_DATLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"STOCK_OUT_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTOCK_OUT_DAT (string STOCK_OUT_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STOCK_OUT_DAT = STOCK_OUT_DAT;  
            return Adapter.SelectByField(obj,"STOCK_OUT_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTOCK_OUT_DAT (string STOCK_OUT_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STOCK_OUT_DAT = STOCK_OUT_DAT;  
            return Adapter.SelectByField(obj,"STOCK_OUT_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTOCK_OUT_DATLST (string STOCK_OUT_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STOCK_OUT_DAT = STOCK_OUT_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STOCK_OUT_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STOCK_OUT_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTOCK_OUT_DATLST (string STOCK_OUT_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STOCK_OUT_DAT = STOCK_OUT_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STOCK_OUT_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_OPTR (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_OPTR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_OPTR (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_OPTR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_OPTRLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_OPTR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_OPTRLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_OPTR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_OPTR (string ORDER_OPTR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_OPTR = ORDER_OPTR;  
            return Adapter.SelectByField(obj,"ORDER_OPTR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_OPTR (string ORDER_OPTR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_OPTR = ORDER_OPTR;  
            return Adapter.SelectByField(obj,"ORDER_OPTR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_OPTRLST (string ORDER_OPTR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_OPTR = ORDER_OPTR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_OPTR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_OPTR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByORDER_OPTRLST (string ORDER_OPTR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ORDER_OPTR = ORDER_OPTR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_OPTR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTATUSLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTATUSLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"STATUS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTATUSLST (string STATUS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectBySTATUSLST (string STATUS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.STATUS = STATUS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"TYPE_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE_CODE (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TYPE_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTYPE_CODELST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTYPE_CODELST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TYPE_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE_CODE (string TYPE_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TYPE_CODE = TYPE_CODE;  
            return Adapter.SelectByField(obj,"TYPE_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTYPE_CODE (string TYPE_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TYPE_CODE = TYPE_CODE;  
            return Adapter.SelectByField(obj,"TYPE_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTYPE_CODELST (string TYPE_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TYPE_CODE = TYPE_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TYPE_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTYPE_CODELST (string TYPE_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TYPE_CODE = TYPE_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TYPE_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBP_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"BP_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBP_CODE (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BP_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByBP_CODELST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BP_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByBP_CODELST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BP_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBP_CODE (string BP_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.BP_CODE = BP_CODE;  
            return Adapter.SelectByField(obj,"BP_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBP_CODE (string BP_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.BP_CODE = BP_CODE;  
            return Adapter.SelectByField(obj,"BP_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByBP_CODELST (string BP_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.BP_CODE = BP_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BP_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BP_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByBP_CODELST (string BP_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.BP_CODE = BP_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BP_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTAL (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTAL (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTAL"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TOTAL",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTAL (double TOTAL )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTAL = TOTAL;  
            return Adapter.SelectByField(obj,"TOTAL");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTAL (double TOTAL, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTAL = TOTAL;  
            return Adapter.SelectByField(obj,"TOTAL",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALLST (double TOTAL )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTAL = TOTAL;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTAL"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTAL duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALLST (double TOTAL, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTAL = TOTAL;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTAL",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFIRST_ALL_DAT (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"FIRST_ALL_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFIRST_ALL_DAT (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"FIRST_ALL_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByFIRST_ALL_DATLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FIRST_ALL_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByFIRST_ALL_DATLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"FIRST_ALL_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFIRST_ALL_DAT (string FIRST_ALL_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.FIRST_ALL_DAT = FIRST_ALL_DAT;  
            return Adapter.SelectByField(obj,"FIRST_ALL_DAT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFIRST_ALL_DAT (string FIRST_ALL_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.FIRST_ALL_DAT = FIRST_ALL_DAT;  
            return Adapter.SelectByField(obj,"FIRST_ALL_DAT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByFIRST_ALL_DATLST (string FIRST_ALL_DAT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.FIRST_ALL_DAT = FIRST_ALL_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FIRST_ALL_DAT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FIRST_ALL_DAT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByFIRST_ALL_DATLST (string FIRST_ALL_DAT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.FIRST_ALL_DAT = FIRST_ALL_DAT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FIRST_ALL_DAT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRPO_NO (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"RPO_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRPO_NO (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RPO_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRPO_NOLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RPO_NO"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRPO_NOLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RPO_NO",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRPO_NO (string RPO_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RPO_NO = RPO_NO;  
            return Adapter.SelectByField(obj,"RPO_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRPO_NO (string RPO_NO, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RPO_NO = RPO_NO;  
            return Adapter.SelectByField(obj,"RPO_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRPO_NOLST (string RPO_NO )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RPO_NO = RPO_NO;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RPO_NO"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RPO_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRPO_NOLST (string RPO_NO, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RPO_NO = RPO_NO;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RPO_NO",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK1 (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"RMRK1");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK1 (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RMRK1",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK1LST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK1"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK1LST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RMRK1",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK1 (string RMRK1 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK1 = RMRK1;  
            return Adapter.SelectByField(obj,"RMRK1");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK1 (string RMRK1, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK1 = RMRK1;  
            return Adapter.SelectByField(obj,"RMRK1",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK1LST (string RMRK1 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK1 = RMRK1;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK1"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK1 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK1LST (string RMRK1, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK1 = RMRK1;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK1",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK2 (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"RMRK2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK2 (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RMRK2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK2LST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK2"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK2LST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RMRK2",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK2 (string RMRK2 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK2 = RMRK2;  
            return Adapter.SelectByField(obj,"RMRK2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRMRK2 (string RMRK2, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK2 = RMRK2;  
            return Adapter.SelectByField(obj,"RMRK2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK2LST (string RMRK2 )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK2 = RMRK2;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK2"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RMRK2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByRMRK2LST (string RMRK2, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.RMRK2 = RMRK2;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RMRK2",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByACTFLGLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByACTFLGLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ACTFLG",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByACTFLGLST (string ACTFLG )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByACTFLGLST (string ACTFLG, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDUSRLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDUSRLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDUSR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDUSRLST (string CTDUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDUSRLST (string CTDUSR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDWKSLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDWKSLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDWKS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDWKSLST (string CTDWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDWKSLST (string CTDWKS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDPGMLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDPGMLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDPGM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDPGMLST (string CTDPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDPGMLST (string CTDPGM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDDTMLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDDTMLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDDTM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDDTMLST (DateTime CTDDTM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCTDDTMLST (DateTime CTDDTM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFUSRLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFUSRLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFUSR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFUSRLST (string MDFUSR )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFUSRLST (string MDFUSR, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFWKSLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFWKSLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFWKS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFWKSLST (string MDFWKS )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFWKSLST (string MDFWKS, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFPGMLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFPGMLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFPGM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFPGMLST (string MDFPGM )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByMDFPGMLST (string MDFPGM, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByLSTMDFLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByLSTMDFLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LSTMDF",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByLSTMDFLST (DateTime LSTMDF )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByLSTMDFLST (DateTime LSTMDF, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByWH_CODELST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByWH_CODELST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"WH_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByWH_CODELST (string WH_CODE )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByWH_CODELST (string WH_CODE, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOUNT (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"COUNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOUNT (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"COUNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCOUNTLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COUNT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCOUNTLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"COUNT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOUNT (int COUNT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.COUNT = COUNT;  
            return Adapter.SelectByField(obj,"COUNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCOUNT (int COUNT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.COUNT = COUNT;  
            return Adapter.SelectByField(obj,"COUNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCOUNTLST (int COUNT )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.COUNT = COUNT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COUNT"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien COUNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByCOUNTLST (int COUNT, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.COUNT = COUNT;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"COUNT",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTALQTY (DMS027_SBL_VIEWEntity obj)
        { 
            return Adapter.SelectByField(obj,"TOTALQTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTALQTY (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TOTALQTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALQTYLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTALQTY"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALQTYLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TOTALQTY",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTALQTY (double TOTALQTY )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTALQTY = TOTALQTY;  
            return Adapter.SelectByField(obj,"TOTALQTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTOTALQTY (double TOTALQTY, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTALQTY = TOTALQTY;  
            return Adapter.SelectByField(obj,"TOTALQTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALQTYLST (double TOTALQTY )
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTALQTY = TOTALQTY;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTALQTY"),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TOTALQTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS027_SBL_VIEWEntity> SelectByTOTALQTYLST (double TOTALQTY, SelectOptions option)
        { 
            DMS027_SBL_VIEWEntity obj = new DMS027_SBL_VIEWEntity();
            obj.TOTALQTY = TOTALQTY;  
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TOTALQTY",option),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectWithConditionLST (DMS027_SBL_VIEWEntity obj)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new DMS027_SBL_VIEWEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS027_SBL_VIEWEntity></returns>
        public List<DMS027_SBL_VIEWEntity> SelectWithConditionLST (DMS027_SBL_VIEWEntity obj,SelectOptions option)
        { 
            return  (List<DMS027_SBL_VIEWEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new DMS027_SBL_VIEWEntity());
        }

}
}
